1. Define the following two variables, it makes life easier, in that you do not have to type in the user name and password every time you issue a command. 

SET ISC_USER=SYSDBA
SET ISC_PASSWORD=masterkey

2. Always make sure you work on a copy of the database, not the production database. Use the operating system to make a copy of the database. You must have exclusive access to the database to do this.

copy employee.gdb database.gdb

3. Now check for database corruption. You must have exclusive access to do this, but since you're working on a copy of the original database, this is not a problem.

gfix -v -full database.gdb

4. If the previous command has indicated that there are problems with the database, we now need to mend it.

gfix -mend -full -ignore database.gdb

5. Now check to see if the corruption has been repaired.

gfix -v -full database.gdb

6. If you still see errors, you should now do a full backup and restore. In its simplest format the backup command line should be:

gbak -backup -v -ignore database.gdb database.gbk

7. However if gbak falls over because it is having trouble with garbage collection, then use the following command:

gbak -backup -v -ignore -garbage 
database.gdb database.gbk

8. If there is corruption in record versions of a limbo transaction, then you may need to include the -limbo switch:

gbak -backup -v -ignore -garbage -limbo database.gdb database.gbk

9. Now create a new database from the backup:

gbak -create -v atlas.gbk atlas_new.gdb

10. If there are problems on the restore, consider using the following switches.

-inactive, if there are index problems, this will restore the database, but will not activate any indexes, you can then do this manually, one at a time. 

-one_at_a_time, this will restore the database one table at a time, and commit the restored tables on each table restore, if there is a major problem, at least you can get some of the data back.



보시는데로 원본이구요.

인터베이스가 깔려있는곳까지 DOS모드로 들어가세요.

C:\>cd C:\Program Files\Interbase\bin

그다음 set 부터 하시면 됩니다.

물론 인덱스/포린키/프라이머리 키등에 따라 에러메세지는 다르게 나타납니다.

저희 같은 경우는 복구율은 거의8~90 되구요.

나머지 10%는 (아주 심하게 깨졋다고 해야하나?) 복구를 못하고 백업으로 대신합니다.

도움이 되셧으면 좋겠네요.

그럼, 수고하세요.